home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / deleteConfig.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  72 lines
  1. /* RCSVER $Id: deleteConfig.sql,v 1.3 1999-07-29 16:29:05-05 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        deleteConfig.sql
  6. * Date:        02/17/1999
  7. * memo:        Randy Wood
  8. * Description:    Delete the data from the config tables.
  9. * Changes:
  10. ************************************************************************* */
  11. delete from dir1list;
  12. delete from dir2list;
  13. delete from rteusage;
  14. delete from wayfset;
  15. delete from wayfares;
  16. delete from ocukeys;
  17. delete from holidays;
  18. delete from faretimes;
  19. delete from faretable;
  20. delete from bus;
  21. delete from trips;
  22. delete from faresets;
  23. delete from sec_levels;
  24. delete from runs;
  25. delete from passwords;
  26. delete from opsecurities;
  27. delete from operations;
  28. delete from jamclr;
  29. delete from garage;
  30. delete from faredescriptions;
  31. delete from farebox;
  32. delete from cashbox;
  33. delete from users;
  34. delete from subsecurities;
  35. delete from status;
  36. delete from routes;
  37. delete from nolog;
  38. delete from global_id;
  39. delete from fareclasses;
  40. delete from custdisp;
  41. delete from configbuttons;
  42. delete from tuningvals;
  43. delete from tuningentry;
  44. delete from sound;
  45. delete from alarmsg;
  46. delete from sound_class;
  47. delete from prompts;
  48. delete from optypes;
  49. delete from ocucmnd;
  50. delete from fbtuning;
  51. delete from currency;
  52. delete from actual_sound;
  53. delete from converr;
  54. delete from tuningtypes;
  55. delete from tableversions;
  56. delete from subsystems;
  57. delete from rectypes;
  58. delete from reports;
  59. delete from report_cat;
  60. delete from master;
  61. delete from introefx;
  62. delete from inplcefx;
  63. delete from hwtypes;
  64. delete from fixedbuttons;
  65. delete from fbfiles;
  66. delete from equiptype;
  67. delete from dlconfig;
  68. delete from curtypes;
  69. delete from configset;
  70. delete from conclefx;
  71. delete from bitdef;
  72.